Filter Examples (In Database)
(In-Database Processing)
Synopsis
Keeps only those rows that satisfy a certain criteria.Description
This operator filters the set of rows based on the criteria defined either by an expression (where you can use your database-specific functions as well), or by a combination of simple expressions. A dialog that you can access by clicking on the appropriate button helps in both cases.
When constructing the filter expression, you may find the built-in macros like process_start_db and t_db useful. Please check the Nest operator help for more information.
Input
example set input
Output
- example set output
Parameters
- condition_class Implementation of the condition. Range: selection
- filters Defines the list of filters to apply. Range: other
- parameter_expression Parameter string for the expression, e.g. 'attribute1 = attribute2'. Put identifiers containing reserved keywords or special characters into square brackets ([]). The square brackets will be replaced by database specific escaping characters (e.g. backticks(`) for Google BigQuery). Uncheck the 'replace square brackets' parameter to disable replacement. Range: string
- replace_square_brackets Replace square brackets. By default square brackets are replaced by the database specific characters used for escaping special identifiers (e.g. with backticks(`) for Google BigQuery). In some situations you may not want to replace the square brackets in the expression. Uncheck this parameter to do so. Range: boolean
- filters_list The list of filters. Range: list
- filters_logic_and Logic operator for filters. Range: boolean
- filters_check_metadata Check meta data for comparators. Range: boolean